"VER1.0","Articulos","Listado de articulos por famlias"
;Versio, Categoria, Descripcion

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
0, 0, 0
0, 0, 0, 0
; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
1,"CABECERA", #FALSE#
"SELECT * , CodigoPostal & ' - ' & Poblacion as Direc, 'Tel : ' & Telefono1 as Tel "
"FROM Configuracion"
""
[CAPSALERA]
0, 0, #FALSE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 3
3,"CABECERA","NombreComercial", 10, 3,"ARIAL", 20, 0, 0, "1000",""
0,"Condiciones : ",10,18,"ARIAL",8,0,0,"1000"
6,"Condiciones",35,18,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Nif", 10, 8, "ARIAL", 8, 0, 0, "1000", ""
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
[FIPEU]
[FIGRUP]

;-----------------------------------------


; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
10, 27, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 17
0,"Estadstica Ventas Cliente por Articulo", 40, 1,"ARIAL",16,0,0,"1000"
0,"Pgina :",170,0,"ARIAL",8,0,0,"1000"
6,"Pagina",195,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",170,5,"ARIAL",8,0,0,"1000"
6,"Fecha",195,5,"ARIAL",8,0,1,"1000",""
1,"linea2", 3, 19, 197, 19,,,
0,"Codigo",5,20,"ARIAL",8,0,0,"1000"
0,"Descripcin",30,20,"ARIAL",8,0,0,"1000"
0,"Unidades", 90,20,"ARIAL",8,0,1,"1000"
0,"Cajas", 103,20,"ARIAL",8,0,1,"1000"
0,"P.Medio", 115,20,"ARIAL",8,0,1,"1000"
0,"Valor", 133,20,"ARIAL",8,0,1,"1000"
0,"Unidades", 152,20,"ARIAL",8,0,1,"1000"
0,"Cajas", 165,20,"ARIAL",8,0,1,"1000"
0,"P.Medio",177,20,"ARIAL",8,0,1,"1000"
0,"Valor",195,20,"ARIAL",8,0,1,"1000"
1,"linea1", 3, 24, 197, 24,,,
[FICAP]

[PEU]
0, 0, #FALSE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;1, "Cuadro", 40, 0, 204, 8, 1, 0,
;0,"Totales Generales :", 50,2.5,"ARIAL",12,0,0,"1000"
;5,0,"TotalPG", 135,3,"ARIAL",10,0,1,"1000","Total"
;5,0,"TotalAG", 195,3,"ARIAL",10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

;-----------------------------------------

;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB0", #FALSE#
"SELECT CodCliente & ' - ' & Nombre as TituloC, CodCliente "
"FROM Clientes"
""
[ORDENACIONS] 0

[CONDICIONS] 1
"CodCliente", "Codigo Cliente", 0, 1 ,-10

[CAPSALERA]
0, 0, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB0","TituloC",5, -13,"ARIAL",10,0,0,"1000",""
[FICAP]

[PEU]
0, 10, #FALSE#, 2, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
1, "Cuadro", 40, 0, 197, 8, 1, 0,
0,"Totales Generales :", 50,2.5,"ARIAL",12,0,0,"1000"
5,0,"TotalPG", 135,3,"ARIAL",10,0,1,"1000","Total"
5,0,"TotalAG", 195,3,"ARIAL",10,0,1,"1000","Total"
[FIPEU]
[FIGRUP]



;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB1", #FALSE#
"SELECT CodFamilia & ' - ' & Descripcion as Titulo2, * "
"FROM Familias"
""
[ORDENACIONS] 1
"CodFamilia", "Codigo Familia", 3

[CONDICIONS] 1
"CodFamilia", "Cod. Familia", 0, 1

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB1","Titulo2",5,0,"ARIAL",10,0,0,"1001",""
[FICAP]
[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
;0,"Totales :",50,0,"ARIAL",10,0,0,"0000"
[CAMPS] 5
1, "lineaH3",117, 0, 137,0,,,
1, "lineaH3",182, 0, 197,0,,,
8, "0", "'Totales Familia ' + Campo('CAB1','CodFamilia') + ' :' ", 50, 2, "ARIAL", 9, 0, 0, "1000", ""
5,0,"TotalP", 135,2,"ARIAL",9,0,1,"1000","Total"
5,0,"TotalA", 195,2,"ARIAL",9,0,1,"1000","Total"
[FIPEU]
[FIGRUP]



;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB2", #FALSE#
"SELECT Articulos.CodArticulo, First(Articulos.CodFamilia) AS CodFamilia, First(Articulos.Descripcion) AS Descripcion, First(Articulos.UnidadBulto) AS UnidadBulto "
"FROM Articulos "
"GROUP BY Articulos.CodArticulo"
[ORDENACIONS] 1
"Articulos.CodArticulo", "Codigo Articulo", 3

[CONDICIONS] 1
"CodFamilia", "CodFamilia", 1, 1, "CAB1", "CodFamilia"
;"VenAlbaLin.CodCliente","Codigo Cliente", 1, 1, "CAB0", "CodCliente"

[CAPSALERA]
0, 5, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
3, "CAB2", "CodArticulo", 5, 0, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB2", "Descripcion", 20, 0, "ARIAL", 8, 55, 0, "0000", ""
[FICAP]

[PEU]
0, 0, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
[FIPEU]

[FIGRUP]



;tipo, NomGrup, Select, From, GropBy
;VenAlbaLin.CodArticulo, VenAlbaLin.Seccion, 
[GRUP]
3,"COS", #FALSE#
"PARAMETERS CliI TEXT, CliF TEXT, ArtiI TEXT, ArtiF TEXT, SecI TEXT, SecF TEXT, FechaPI DATETIME, FechaPF DATETIME, FechaAI DATETIME, FechaAF DATETIME; SELECT Sum(TPCantidad) AS CanP, Sum(TPValor) AS VaP, Sum(PrecioMedioP) AS PrecioMP, Sum(TACantidad) AS CanA, Sum(TAValor) AS VaA, Sum(PrecioMedioA) AS PrecioMA "
"FROM [#VentasCotoC] "
" HAVING Sum(TPCantidad) <>0 OR Sum(TACantidad) <>0"

;"VenAlbaLin.Seccion", "VenAlbaLin.Seccion", 1, 1, "CAB1", "VenAlbaLin.Seccion"
[CONDICIONS] 5
"Cli", "CodCliente", 1, 1, "CAB0", "CodCliente"
"Arti", "CodArticulo", 1, 1, "CAB2", "CodArticulo"
"Sec","Seccion",0,1
"FechaP","Fecha Periodo",0,2
"FechaA","Fecha Acumulado",0,2
;" VenAlbaLin.Seccion","Seccion",0,1
;" ( Facturado= false) ","",4
;" VenAlbaLin.CodCliente","Codigo Cliente", 5, 1, "CAB2"

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
;'  TotalCantidad / Articulos.UnidadBulto as Cajitas
;3,"COS","Cajitas",155,0,"ARIAL",8,0,1,"0000","Precio"
;'  Valor / TotalCantidad as PrecioMedio 
;8, "1", "val(Campo('COS','Valor'))/val(Campo('COS','TotalCantidad')) ", 180, 0, "ARIAL", 8, 0, 1, "0000", "Precio"
[CAMPS] 8
3, "COS", "CanP", 90, 0, "ARIAL",8,0,1,"0000",""
8, "1", "CAJAS( Campo('COS','CanP'), Campo('CAB2','UnidadBulto'), Campo('COS','VaP')) ", 103, 0, "ARIAL", 8, 0, 1, "0000", "###,###;;\ ---"
3, "COS", "PrecioMP", 115,0,"ARIAL",8,0,1,"0000","Precio"
3, "COS", "VaP", 133,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "CanA", 152,0,"ARIAL",8,0,1,"0000",""
8, "1", "CAJAS( Campo('COS','CanA'), Campo('CAB2','UnidadBulto'), Campo('COS','VaP')) ", 165, 0, "ARIAL", 8, 0, 1, "0000", "###,###;;\ ---"
3, "COS", "PrecioMA", 177,0,"ARIAL",8,0,1,"0000","Precio"
3, "COS", "VaA", 195,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]

[CALCULS] 4
"TotalP","COS","VaP","CAB1"
"TotalPG","COS","VaP","CAB0"
"TotalA","COS","VaA","CAB1"
"TotalAG","COS","VaA","CAB0"

[FIDOCUM]


